DeepJoin: Joinable Table Discovery with Pre-trained Language Models

Due to the usefulness in data enrichment for data analysis tasks, joinable table discovery has become an important operation in data lake management. Existing approaches target equi-joins, the most common way of combining tables for creating a unified view, or semantic joins, which tolerate misspellings and different formats to deliver more join results. They are either exact solutions whose running time is linear in the sizes of query column and target table repository or approximate solutions lacking precision. In this paper, we propose Deepjoin, a deep learning model for accurate and efficient joinable table discovery. Our solution is an embedding-based retrieval, which employs a pre-trained language model (PLM) and is designed as one framework serving both equi- and semantic joins. We propose a set of contextualization options to transform column contents to a text sequence. The PLM reads the sequence and is fine-tuned to embed columns to vectors such that columns are expected to be joinable if they are close to each other in the vector space. Since the output of the PLM is fixed in length, the subsequent search procedure becomes independent of the column size. With a state-of-the-art approximate nearest neighbor search algorithm, the search time is logarithmic in the repository size. To train the model, we devise the techniques for preparing training data as well as data augmentation. The experiments on real datasets demonstrate that by training on a small subset of a corpus, Deepjoin generalizes to large datasets and its precision consistently outperforms other approximate solutions'. Deepjoin is even more accurate than an exact solution to semantic joins when evaluated with labels from experts. Moreover, when equipped with a GPU, Deepjoin is up to two orders of magnitude faster than existing solutions

A reduced brain and liver FDG uptake

Purpose : To investigate whether or not the physiological brain and liver FDG uptake are decreased in patients with highly accelerated glycolysis lesions. Methods : We retrospectively analyzed 51 patients with malignant lymphoma. We compared the FDG uptake in the brain and liver of the patients with that in a control group. In 24 patients with a complete response (CR) or partial response (PR) to treatment, we compared the brain and liver uptake before and after treatment. Results : The maximum standardized uptake value (SUVmax) and total glycolytic volume (TGV) of the brain as well as the SUVmax and mean standardized uptake value (SUVmean) of the liver in malignant lymphoma patients were 13.1 ± 2.3, 7386.3 ± 1918.4, 3.2 ± 0.5, and 2.3 ± 0.4, respectively ; in the control group, these values were 14.9 ± 2.4, 8566.2 ± 1659.5, 3.4 ± 0.4, and 2.5 ± 0.3, respectively. The SUVmax and TGV of the brain and the SUVmean of the liver in malignant lymphoma patients were significantly lower than the control group. The SUVmax and TGV of the brain after treatment were significantly higher than before treatment. Both the SUVmax and SUVmean of liver after treatment were higher than before treatment, but not significant. Conclusion : A decreased physiological brain and liver FDG uptake is caused by highly accelerated lesion glycolysis

ORAI1 Genetic Polymorphisms Associated with the Susceptibility of Atopic Dermatitis in Japanese and Taiwanese Populations

Atopic dermatitis is a chronic inflammatory skin disease. Multiple genetic and environmental factors are thought to be responsible for susceptibility to AD. In this study, we collected 2,478 DNA samples including 209 AD patients and 729 control subjects from Taiwanese population and 513 AD patients and 1027 control subject from Japanese population for sequencing and genotyping ORAI1. A total of 14 genetic variants including 3 novel single-nucleotide polymorphisms (SNPs) in the ORAI1 gene were identified. Our results indicated that a non-synonymous SNP (rs3741596, Ser218Gly) associated with the susceptibility of AD in the Japanese population but not in the Taiwanese population. However, there is another SNP of ORAI1 (rs3741595) associated with the risk of AD in the Taiwanese population but not in the Japanese population. Taken together, our results indicated that genetic polymorphisms of ORAI1 are very likely to be involved in the susceptibility of AD

Variants of C-C Motif Chemokine 22 (CCL22) Are Associated with Susceptibility to Atopic Dermatitis: Case-Control Studies

Atopic dermatitis (AD) is a common inflammatory skin disease caused by multiple genetic and environmental factors. AD is characterized by the local infiltration of T helper type 2 (Th2) cells. Recent clinical studies have shown important roles of the Th2 chemokines, CCL22 and CCL17 in the pathogenesis of AD. To investigate whether polymorphisms of the CCL22 gene affect the susceptibility to AD, we conducted association studies and functional studies of the related variants. We first resequenced the CCL22 gene and found a total of 39 SNPs. We selected seven tag SNPs in the CCL22 gene, and conducted association studies using two independent Japanese populations (1st population, 916 cases and 1,032 controls; 2nd population 1,034 cases and 1,004 controls). After the association results were combined by inverse variance method, we observed a significant association at rs4359426 (meta-analysis, combined P = 9.6×10−6; OR, 0.74; 95% CI, 0.65–0.85). Functional analysis revealed that the risk allele of rs4359426 contributed to higher expression levels of CCL22 mRNA. We further examined the allelic differences in the binding of nuclear proteins by electrophoretic mobility shift assay. The signal intensity of the DNA-protein complex derived from the G allele of rs223821, which was in absolute LD with rs4359426, was higher than that from the A allele. Although further functional analyses are needed, it is likely that related variants play a role in susceptibility to AD in a gain-of-function manner. Our findings provide a new insight into the etiology and pathogenesis of AD

The whole blood transcriptional regulation landscape in 465 COVID-19 infected samples from Japan COVID-19 Task Force

「コロナ制圧タスクフォース」COVID-19患者由来の血液細胞における遺伝子発現の網羅的解析 --重症度に応じた遺伝子発現の変化には、ヒトゲノム配列の個人差が影響する--. 京都大学プレスリリース. 2022-08-23.Coronavirus disease 2019 (COVID-19) is a recently-emerged infectious disease that has caused millions of deaths, where comprehensive understanding of disease mechanisms is still unestablished. In particular, studies of gene expression dynamics and regulation landscape in COVID-19 infected individuals are limited. Here, we report on a thorough analysis of whole blood RNA-seq data from 465 genotyped samples from the Japan COVID-19 Task Force, including 359 severe and 106 non-severe COVID-19 cases. We discover 1169 putative causal expression quantitative trait loci (eQTLs) including 34 possible colocalizations with biobank fine-mapping results of hematopoietic traits in a Japanese population, 1549 putative causal splice QTLs (sQTLs; e.g. two independent sQTLs at TOR1AIP1), as well as biologically interpretable trans-eQTL examples (e.g., REST and STING1), all fine-mapped at single variant resolution. We perform differential gene expression analysis to elucidate 198 genes with increased expression in severe COVID-19 cases and enriched for innate immune-related functions. Finally, we evaluate the limited but non-zero effect of COVID-19 phenotype on eQTL discovery, and highlight the presence of COVID-19 severity-interaction eQTLs (ieQTLs; e.g., CLEC4C and MYBL2). Our study provides a comprehensive catalog of whole blood regulatory variants in Japanese, as well as a reference for transcriptional landscapes in response to COVID-19 infection

DOCK2 is involved in the host genetics and biology of severe COVID-19

「コロナ制圧タスクフォース」COVID-19疾患感受性遺伝子DOCK2の重症化機序を解明 --アジア最大のバイオレポジトリーでCOVID-19の治療標的を発見--. 京都大学プレスリリース. 2022-08-10.Identifying the host genetic factors underlying severe COVID-19 is an emerging challenge. Here we conducted a genome-wide association study (GWAS) involving 2, 393 cases of COVID-19 in a cohort of Japanese individuals collected during the initial waves of the pandemic, with 3, 289 unaffected controls. We identified a variant on chromosome 5 at 5q35 (rs60200309-A), close to the dedicator of cytokinesis 2 gene (DOCK2), which was associated with severe COVID-19 in patients less than 65 years of age. This risk allele was prevalent in East Asian individuals but rare in Europeans, highlighting the value of genome-wide association studies in non-European populations. RNA-sequencing analysis of 473 bulk peripheral blood samples identified decreased expression of DOCK2 associated with the risk allele in these younger patients. DOCK2 expression was suppressed in patients with severe cases of COVID-19. Single-cell RNA-sequencing analysis (n = 61 individuals) identified cell-type-specific downregulation of DOCK2 and a COVID-19-specific decreasing effect of the risk allele on DOCK2 expression in non-classical monocytes. Immunohistochemistry of lung specimens from patients with severe COVID-19 pneumonia showed suppressed DOCK2 expression. Moreover, inhibition of DOCK2 function with CPYPP increased the severity of pneumonia in a Syrian hamster model of SARS-CoV-2 infection, characterized by weight loss, lung oedema, enhanced viral loads, impaired macrophage recruitment and dysregulated type I interferon responses. We conclude that DOCK2 has an important role in the host immune response to SARS-CoV-2 infection and the development of severe COVID-19, and could be further explored as a potential biomarker and/or therapeutic target

Appropriate Method of Administering Vasopressors for Maternal Hypotension Associated with Combined Spinal Epidural Anesthesia in Elective Cesarean Section: Impact on Postnatal Respiratory Support for Newborns

Background and Objectives: Vasopressors are used for treating maternal hypotension. However, the appropriate administration method and effects on newborns have not been reported. We evaluated maternal blood pressure fluctuation and neonatal findings in patients who received continuous vasopressor administration during elective cesarean sections and those who received bolus vasopressor administration upon onset of hypotension. Materials and Methods: We retrospectively analyzed the data of 220 patients scheduled for elective cesarean delivery under spinal anesthesia at Mie University Hospital between April 2017 and March 2021. The patients were classified according to the method of vasopressor administration. Maternal information, intraoperative maternal blood pressure fluctuation, and neonatal findings were examined. A multiple regression analysis was performed for the administration of postpartum neonatal respiratory support using maternal background information and other variables related to blood pressure changes as independent variables. Results: The Continuous group and the Bolus group were composed of 98 and 122 patients, respectively. No difference was observed in maternal background information between the groups. Significant changes were noted in several blood pressure parameters between both groups. As for neonatal parameters, newborns of Bolus group patients had lower pO2, 1 min and 5 min Apgar scores, and required more respiratory support than those of Continuous group patients. In the multiple regression analysis, the groups and maternal post-anesthesia diastolic blood pressure variability were considered explanatory variables. Conclusions: Maternal hypotension and the need for neonatal respiratory support associated with anesthesia administration in elective cesarean section may be improved by continuous vasopressor administration upon induction of combined spinal–epidural anesthesia